SELECT dem.provider_no AS Provider, demph.demographic_no AS DemNo, demph.pharmacyID AS PharID, ph.name AS Pharmacy, ph.address AS PharmacyAddr, dem.last_name AS PatLName, dem.first_name AS PatFName FROM demographicPharmacy demph LEFT JOIN demographic dem ON demph.demographic_no = dem.demographic_no LEFT JOIN pharmacyInfo ph ON demph.pharmacyID = ph.recordID WHERE demph.status = 1 AND dem.provider_no = '{provider}' ORDER BY dem.provider_no, demph.pharmacyID, dem.last_name select distinct provider_no, concat(last_name,',',first_name,'(',provider_no,')') from provider where provider_type = 'doctor' order by last_name ;